Search Results for: ".22 single shot pistol"

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='.22 single shot pistol' and kword <> '' and kword is not NULL and site='sportsman'

SELECT distinct a.style_id,
 case a.style_id 
 
 when 199494 then 1 
 when 277408 then 2 
 when 277407 then 3 
 when 277397 then 4 
 when 277405 then 5 
 when 277406 then 6 
 when 277410 then 7 
 when 277409 then 8 
 when 277403 then 9 
 when 284192 then 10 
 when 223181 then 11 
 when 284191 then 12 
 when 291864 then 13 
 when 220936 then 14 
 when 291813 then 15 
 when 251706 then 16 
 when 283325 then 17 
 when 36622 then 18 
 when 283371 then 19 
 when 117774 then 20 
 when 247778 then 21 
 when 283257 then 22 
 when 264572 then 23 
 when 288921 then 24 
 when 288923 then 25 
 when 13368 then 26 
 when 129242 then 27 
 when 236929 then 28 
 when 283858 then 29 
 when 272035 then 30 
 when 283213 then 31 
 when 210301 then 32 
 when 91822 then 33 
 when 129326 then 34 
 when 123871 then 35 
 when 222418 then 36 
 when 247767 then 37 
 when 277404 then 38 
 when 13370 then 39 
 when 222422 then 40 
 when 286731 then 41 
 when 205607 then 42 
 when 236945 then 43 
 when 116595 then 44 
 when 283379 then 45 
 when 205604 then 46 
 when 222421 then 47 
 when 222424 then 48 
 when 36605 then 49 
 when 205608 then 50 
 when 36613 then 51 
 when 291845 then 52 
 when 152532 then 53 
 when 143454 then 54 
 when 199253 then 55 
 when 114201 then 56 
 when 302056 then 57 
 when 287764 then 58 
 when 216913 then 59 
 when 216914 then 60 
 when 216910 then 61 
 when 216911 then 62 
 when 197692 then 63 
 when 294587 then 64 
 when 309642 then 65 
 when 262116 then 66 
 when 276348 then 67 
 when 223177 then 68 
 when 262110 then 69 
 when 147471 then 70 
 when 188448 then 71 
 when 139987 then 72 
 when 275955 then 73 
 when 193838 then 74 
 when 249030 then 75 
 when 253191 then 76 
 when 192981 then 77 
 when 268752 then 78 
 when 252431 then 79 
 when 264770 then 80 
 when 266826 then 81 
 when 181144 then 82 
 when 181143 then 83 
 when 247202 then 84 
 when 268750 then 85 
 when 134500 then 86 
 when 195457 then 87 
 when 195458 then 88 
 when 165252 then 89 
 when 227668 then 90 
 when 268570 then 91 
 when 211446 then 92 
 when 260590 then 93 
 when 268561 then 94 
 when 260975 then 95 
 when 266384 then 96 
 when 268753 then 97 
 when 36024 then 98 
 when 176261 then 99 
 when 247210 then 100 
 when 249033 then 101 
 when 199045 then 102 
 when 199043 then 103 
 when 214426 then 104 
 when 247212 then 105 
 when 247211 then 106 
 when 36610 then 107 
 when 263414 then 108 
 when 272084 then 109 
 when 253192 then 110 
 when 264974 then 111 
 when 253193 then 112 
 when 264205 then 113 
 when 268751 then 114 
 when 193178 then 115 
 when 199044 then 116 
 when 260634 then 117 
 when 253159 then 118 
 when 212024 then 119 
 when 253157 then 120 
 when 253156 then 121 
 when 44655 then 122 
 when 114238 then 123 
 when 264969 then 124 
 when 270142 then 125 
 when 272136 then 126 
 when 282678 then 127 
 when 272085 then 128 
 when 262599 then 129 
 when 272086 then 130 
 when 262084 then 131 
 when 283265 then 132 
 when 289828 then 133 
 when 298405 then 134 
 when 36606 then 135 
 when 36608 then 136 
 when 288985 then 137 
 when 209922 then 138 
 when 212023 then 139 
 when 220446 then 140 
 when 260636 then 141 
 when 284422 then 142 
 when 220447 then 143 
 when 188447 then 144 
 when 272093 then 145 
 when 272644 then 146 
 when 272094 then 147 
 when 212823 then 148 
 when 260637 then 149 
 when 303608 then 150 
 when 268754 then 151 
 when 303607 then 152 
 when 266383 then 153 
 when 261808 then 154 
 when 298408 then 155 
 when 188446 then 156 
 when 272095 then 157 
 when 277728 then 158 
 when 212089 then 159 
 when 36623 then 160 
 when 294675 then 161 
 when 298407 then 162 
 when 193139 then 163 
 when 286757 then 164 
 when 296153 then 165 
 when 192324 then 166 
 when 281487 then 167 
 when 277729 then 168 
 when 212813 then 169 
 when 261957 then 170 
 when 262601 then 171 
 when 277726 then 172 
 when 289693 then 173 
 when 268051 then 174 
 when 298406 then 175 
 when 298409 then 176 
 when 36047 then 177 
 when 119052 then 178 
 when 149701 then 179 
 when 158037 then 180 
 when 118963 then 181 
 when 255511 then 182 
 when 303609 then 183 
 when 44653 then 184 
 when 44657 then 185 
 when 44656 then 186 
 when 153094 then 187 
 when 252569 then 188 
 when 44652 then 189 
 when 281157 then 190 
 when 154946 then 191 
 when 40287 then 192 
 when 291252 then 193 
 when 260629 then 194 
 when 204787 then 195 
 when 107584 then 196 
 when 291723 then 197 
 when 285532 then 198 
 when 212280 then 199 
 when 283281 then 200 
 when 281630 then 201 
 when 287957 then 202 
 when 253589 then 203 
 when 40312 then 204 
 when 247206 then 205 
 when 227610 then 206 
 when 149785 then 207 
 when 193837 then 208 
 when 227609 then 209 
 when 283220 then 210 
 when 203703 then 211 
 when 264203 then 212 
 when 309625 then 213 
 when 256579 then 214 
 when 283232 then 215 
 when 148973 then 216 
 when 250391 then 217 
 when 264970 then 218 
 when 283389 then 219 
 when 44675 then 220 
 when 255425 then 221 
 when 278253 then 222 
 when 283323 then 223 
 when 283372 then 224 
 when 264207 then 225 
 when 283329 then 226 
 when 296453 then 227 
 when 227669 then 228 
 when 293281 then 229 
 when 44674 then 230 
 when 264972 then 231 
 when 307862 then 232 
 when 246578 then 233 
 when 277730 then 234 
 when 268636 then 235 
 when 262597 then 236 
 when 225308 then 237 
 when 252482 then 238 
 when 277727 then 239 
 when 255014 then 240 
 when 254547 then 241 
 when 248858 then 242 
 when 290588 then 243 
 when 61944 then 244 
 when 288066 then 245 
 when 294688 then 246 
 when 12705 then 247 
 when 218419 then 248 
 when 218421 then 249 
 when 91819 then 250 
 when 12666 then 251 
 when 87502 then 252 
 when 155925 then 253 
 when 217477 then 254 
 when 310133 then 255 
 when 264967 then 256 
 when 254548 then 257 
 when 262113 then 258 
 when 19093 then 259 
 when 267834 then 260 
 when 117161 then 261 
 when 13387 then 262 
 when 13393 then 263 
 when 170313 then 264 
 when 13388 then 265 
 when 170314 then 266 
 when 193145 then 267 
 when 209128 then 268 
 when 254492 then 269 
 when 274428 then 270 
 when 213796 then 271 
 when 260834 then 272 
 when 145797 then 273 
 when 143656 then 274 
 when 13394 then 275 
 when 13395 then 276 
 when 8388 then 277 
 when 13390 then 278 
 when 116916 then 279 
 when 193144 then 280 
 when 245236 then 281 
 when 277039 then 282 
 when 8391 then 283 
 when 91821 then 284 
 when 8392 then 285 
 when 205600 then 286 
 when 287059 then 287 
 when 216706 then 288 
 when 173212 then 289 
 when 252835 then 290 
 when 287062 then 291 
 when 287250 then 292 
 when 205612 then 293 
 when 205599 then 294 
 when 13397 then 295 
 when 13396 then 296 
 when 13392 then 297 
 when 280250 then 298 
 when 257098 then 299 
 when 44629 then 300 
 when 170312 then 301 
 when 251562 then 302 
 when 285719 then 303 
 when 216921 then 304 
 when 252348 then 305 
 when 252347 then 306 
 when 214112 then 307 
 when 262259 then 308 
 when 8387 then 309 
 when 205603 then 310 
 when 216915 then 311 
 when 216918 then 312 
 when 216919 then 313 
 when 196899 then 314 
 when 216922 then 315 
 when 216905 then 316 
 when 283210 then 317 
 when 216916 then 318 
 when 216908 then 319 
 when 216909 then 320 
 when 216904 then 321 
 when 40364 then 322 
 when 151117 then 323 
 when 127352 then 324 
 when 126077 then 325 
 when 232437 then 326 
 when 216924 then 327 
 when 249587 then 328 
 when 205601 then 329 
 when 40286 then 330 
 when 40288 then 331 
 when 210682 then 332 
 when 266240 then 333 
 when 220611 then 334 
 when 249588 then 335 
 when 216907 then 336 
 when 220612 then 337 
 when 51483 then 338 
 when 51482 then 339 
 when 285530 then 340 
 when 51481 then 341 
 when 215619 then 342 
 when 269481 then 343 
 when 310314 then 344 
 when 23409 then 345 
 when 296464 then 346 
 when 40337 then 347 
 when 51493 then 348 
 when 264968 then 349 
 when 114053 then 350 
 when 36595 then 351 
 when 102137 then 352 
 when 23413 then 353 
 when 266601 then 354 
 when 36624 then 355 
 when 36607 then 356 
 when 216906 then 357 
 when 220610 then 358 
 when 105900 then 359 
 when 269615 then 360 
 when 285534 then 361 
 when 287585 then 362 
 when 193163 then 363 
 when 87656 then 364 
 when 205777 then 365 
 when 74998 then 366 
 when 249293 then 367 
 when 119450 then 368 
 when 205776 then 369 
 when 158090 then 370 
 when 51499 then 371 
 when 51485 then 372 
 when 103825 then 373 
 when 289268 then 374 
 when 91793 then 375 
 when 144147 then 376 
 when 220609 then 377 
 when 260554 then 378 
 when 291471 then 379 
 when 247362 then 380 
 when 89710 then 381 
 when 216278 then 382 
 when 201672 then 383 
 when 297546 then 384 
 when 260562 then 385 
 when 104297 then 386 
 when 87653 then 387 
 when 267920 then 388 
 when 51494 then 389 
 when 144547 then 390 
 when 289833 then 391 
 when 218420 then 392 
 when 114191 then 393 
 when 193158 then 394 
 when 40374 then 395 
 when 247360 then 396 
 when 260564 then 397 
 when 23408 then 398 
 when 23407 then 399 
 when 219848 then 400 
 when 36614 then 401 
 when 36619 then 402 
 when 173699 then 403 
 when 289418 then 404 
 when 262811 then 405 
 when 51502 then 406 
 when 188340 then 407 
 when 115864 then 408 
 when 289698 then 409 
 when 76572 then 410 
 when 254110 then 411 
 when 207007 then 412 
 when 51479 then 413 
 when 161895 then 414 
 when 74926 then 415 
 when 210684 then 416 
 when 260560 then 417 
 when 260552 then 418 
 when 217478 then 419 
 when 249292 then 420 
 when 282653 then 421 
 when 260561 then 422 
 when 271477 then 423 
 when 279430 then 424 
 when 193153 then 425 
 when 193152 then 426 
 when 193157 then 427 
 when 193147 then 428 
 when 306678 then 429 
 when 40276 then 430 
 when 301920 then 431 
 when 281593 then 432 
 when 281594 then 433 
 when 288076 then 434 
 when 285851 then 435 
 when 192980 then 436 
 when 94198 then 437 
 when 145772 then 438 
 when 242384 then 439 
 when 193149 then 440 
 when 23419 then 441 
 when 247488 then 442 
 when 222650 then 443 
 when 193146 then 444 
 when 249289 then 445 
 when 288073 then 446 
 when 275985 then 447 
 when 275983 then 448 
 when 296553 then 449 
 when 193143 then 450 
 when 266628 then 451 
 when 293278 then 452 
 when 277035 then 453 
 when 280316 then 454 
 when 40271 then 455 
 when 170184 then 456 
 when 51486 then 457 
 when 192979 then 458 
 when 192829 then 459 
 when 242377 then 460 
 when 10152 then 461 
 when 131287 then 462 
 when 249031 then 463 
 when 297549 then 464 
 when 266631 then 465 
 when 287061 then 466 
 when 216279 then 467 
 when 23410 then 468 
 when 247528 then 469 
 when 201671 then 470 
 when 274646 then 471 
 when 193137 then 472 
 when 247491 then 473 
 when 293071 then 474 
 when 293069 then 475 
 when 293070 then 476 
 when 266632 then 477 
 when 184495 then 478 
 when 178949 then 479 
 when 268579 then 480 
 when 268587 then 481 
 when 268569 then 482 
 when 268538 then 483 
 when 277693 then 484 
 when 296372 then 485 
 when 267685 then 486 
 when 270147 then 487 
 when 51496 then 488 
 when 268550 then 489 
 when 261810 then 490 
 when 268545 then 491 
 when 304938 then 492 
 when 297550 then 493 
 when 296455 then 494 
 when 298721 then 495 
 when 210683 then 496 
 when 222539 then 497 
 when 260563 then 498 
 when 277036 then 499 
 when 280321 then 500 
 when 280320 then 501 
 when 288582 then 502 
 when 273433 then 503 
 when 273434 then 504 
 when 203321 then 505 
 when 247529 then 506 
 when 279063 then 507 
 when 288583 then 508 
 when 192469 then 509 
 when 103815 then 510 
 when 216898 then 511 
 when 210595 then 512 
 when 79854 then 513 
 when 281084 then 514 
 when 298825 then 515 
 when 173188 then 516 
 when 222706 then 517 
 when 247485 then 518 
 when 36626 then 519 
 when 79793 then 520 
 when 222538 then 521 
 when 222537 then 522 
 when 280317 then 523 
 when 280318 then 524 
 when 266627 then 525 
 when 293138 then 526 
 when 277038 then 527 
 when 88520 then 528 
 when 36627 then 529 
 when 51500 then 530 
 when 268591 then 531 
 when 291860 then 532 
 when 227241 then 533 
 when 307740 then 534 
 when 213783 then 535 
 when 309733 then 536 
 when 309734 then 537 
 when 227189 then 538 
 when 277037 then 539 
 when 51478 then 540 
 when 124298 then 541 
 when 72903 then 542 
 when 118362 then 543 
 when 266865 then 544 
 when 247484 then 545 
 when 247500 then 546 
 when 247498 then 547 
 when 247495 then 548 
 when 293261 then 549 
 when 288383 then 550 
 when 264156 then 551 
 when 195456 then 552 
 when 247208 then 553 
 when 51501 then 554 
 when 199095 then 555 
 when 40266 then 556 
 when 158089 then 557 
 when 111984 then 558 
 when 288213 then 559 
 when 214894 then 560 
 when 210292 then 561 
 when 143333 then 562 
 when 134569 then 563 
 when 274125 then 564 
 when 40270 then 565 
 when 161190 then 566 
 when 262097 then 567 
 when 294887 then 568 
 when 304720 then 569 
 when 247209 then 570 
 when 266212 then 571 
 when 40258 then 572 
 when 111461 then 573 
 when 152377 then 574 
 when 191585 then 575 
 when 189019 then 576 
 when 266965 then 577 
 when 104864 then 578 
 when 114636 then 579 
 when 106369 then 580 
 when 122404 then 581 
 when 122415 then 582 
 when 133124 then 583 
 when 191785 then 584 
 when 305065 then 585 
 when 192875 then 586 
 when 122763 then 587 
 when 249639 then 588 
 when 188283 then 589 
 when 66260 then 590 
 when 137587 then 591 
 when 40295 then 592 
 when 147502 then 593 
 when 163726 then 594 
 when 129234 then 595 
 when 169698 then 596 
 when 249640 then 597 
 when 169095 then 598 
 when 270873 then 599 
 when 152417 then 600 
 when 204221 then 601 
 when 123916 then 602 
 when 248401 then 603 
 when 202351 then 604 
 when 155342 then 605 
 when 114014 then 606 
 when 158550 then 607 
 when 199242 then 608 
 when 266703 then 609 
 when 196068 then 610 
 when 269510 then 611 
 when 202874 then 612 
 when 191305 then 613 
 when 177536 then 614 
 when 262922 then 615 
 when 264982 then 616 
 when 116759 then 617 
 when 199591 then 618 
 when 201902 then 619 
 when 123902 then 620 
 when 170108 then 621 
 when 277320 then 622 
 when 138367 then 623 
 when 176523 then 624 
 when 188884 then 625 
 when 217041 then 626 
 when 35035 then 627 
 when 202048 then 628 
 when 255698 then 629 
 when 107138 then 630 
 when 165118 then 631 
 when 156361 then 632 
 when 263234 then 633 
 when 125777 then 634 
 when 193108 then 635 
 when 273793 then 636 
 when 251455 then 637 
 when 87677 then 638 
 when 168708 then 639 
 when 154969 then 640 
 when 201522 then 641 
 when 256758 then 642 
 when 193477 then 643 
 when 193478 then 644 
 when 35032 then 645 
 when 191304 then 646 
 when 119180 then 647 
 when 248404 then 648 
 when 165120 then 649 
 when 260753 then 650 
 when 125608 then 651 
 when 133832 then 652 
 when 133831 then 653 
 when 116155 then 654 
 when 155604 then 655 
 when 103201 then 656 
 when 109823 then 657 
 when 131365 then 658 
 when 193533 then 659 
 when 290544 then 660 
 when 190017 then 661 
 when 35031 then 662 
 when 205866 then 663 
 when 193604 then 664 
 when 213442 then 665 
 when 119909 then 666 
 when 205865 then 667 
 when 220055 then 668 
 when 266213 then 669 
 when 205395 then 670 
 when 160859 then 671 
 when 192347 then 672 
 when 157813 then 673 
 when 257017 then 674 
 when 189166 then 675 
 when 266940 then 676 
 when 216998 then 677 
 when 132077 then 678 
 when 168536 then 679 
 when 206588 then 680 
 when 192328 then 681 
 when 35036 then 682 
 when 151724 then 683 
 when 251459 then 684 
 when 204766 then 685 
 when 48699 then 686 
 when 247437 then 687 
 when 261539 then 688 
 when 155320 then 689 
 when 192487 then 690 
 when 251979 then 691 
 when 147503 then 692 
 when 38932 then 693 
 when 152463 then 694 
 when 138439 then 695 
 when 144905 then 696 
 when 266942 then 697 
 when 84067 then 698 
 when 44839 then 699 
 when 245695 then 700 
 when 44748 then 701 
 when 268451 then 702 
 when 268445 then 703 
 when 279982 then 704 
 when 247619 then 705 
 when 281742 then 706 
 when 280169 then 707 
 when 206320 then 708 
 when 206983 then 709 
 when 263460 then 710 
 when 263455 then 711 
 when 44843 then 712 
 when 213317 then 713 
 when 260640 then 714 
 when 262614 then 715 
 when 129235 then 716 
 when 38930 then 717 
 when 213253 then 718 
 when 248698 then 719 
 when 252461 then 720 
 when 138567 then 721 
 when 217040 then 722 
 when 268476 then 723 
 when 268262 then 724 
 when 268359 then 725 
 when 268409 then 726 
 when 264161 then 727 
 when 247820 then 728 
 when 268450 then 729 
 when 136939 then 730 
 when 138297 then 731 
 when 38931 then 732 
 when 274643 then 733 
 when 269278 then 734 
 when 192488 then 735 
 when 245694 then 736 
 when 47938 then 737 
 when 193107 then 738 
 when 271642 then 739 
 when 262617 then 740 
 when 262613 then 741 
 when 134604 then 742 
 when 217042 then 743 
 when 116148 then 744 
 when 205605 then 745 
 when 222595 then 746 
 when 113147 then 747 
 when 144548 then 748 
 when 152464 then 749 
 when 249560 then 750 
 when 251683 then 751 
 when 262138 then 752 
 when 206321 then 753 
 when 189649 then 754 
 when 111392 then 755 
 when 245412 then 756 
 when 278792 then 757 
 when 4740 then 758 
 when 218523 then 759 
 when 194075 then 760 
 when 4738 then 761 
 when 289961 then 762 
 when 274644 then 763 
 when 154963 then 764 
 when 247816 then 765 
 when 268416 then 766 
 when 268447 then 767 
 when 268427 then 768 
 when 268448 then 769 
 when 279949 then 770 
 when 268337 then 771 
 when 268391 then 772 
 when 280015 then 773 
 when 312404 then 774 
 when 279951 then 775 
 when 44661 then 776 
 when 257263 then 777 
 when 73024 then 778 
 when 253983 then 779 
 when 251210 then 780 
 when 277899 then 781 
 when 277317 then 782 
 when 215153 then 783 
 when 266941 then 784 
 when 267070 then 785 
 when 262612 then 786 
 when 113728 then 787 
 when 24188 then 788 
 when 161941 then 789 
 when 116008 then 790 
 when 124007 then 791 
 when 217043 then 792 
 when 268357 then 793 
 when 145486 then 794 
 when 170107 then 795 
 when 196898 then 796 
 when 216883 then 797 
 when 132529 then 798 
 when 138442 then 799 
 when 289964 then 800 
 when 103054 then 801 
 when 214886 then 802 
 when 253370 then 803 
 when 280982 then 804 
 when 214586 then 805 
 when 214587 then 806 
 when 4741 then 807 
 when 48169 then 808 
 when 134600 then 809 
 when 257284 then 810 
 when 204767 then 811 
 when 220134 then 812 
 when 247439 then 813 
 when 281141 then 814 
 when 305251 then 815 
 when 274642 then 816 
 when 262788 then 817 
 when 151157 then 818 
 when 280866 then 819 
 when 249009 then 820 
 when 252550 then 821 
 when 251681 then 822 
 when 254207 then 823 
 when 188659 then 824 
 when 247438 then 825 
 when 192327 then 826 
 when 267296 then 827 
 when 225324 then 828 
 when 297979 then 829 
 when 138563 then 830 
 when 153403 then 831 
 when 144193 then 832 
 when 305036 then 833 
 when 291312 then 834 
 when 293202 then 835 
 when 132723 then 836 
 when 48701 then 837 
 when 193109 then 838 
 when 262999 then 839 
 when 48172 then 840 
 when 262615 then 841 
 when 213453 then 842 
 when 132724 then 843 
 when 213538 then 844 
 when 222481 then 845 
 when 220615 then 846 
 when 281649 then 847 
 when 301145 then 848 
 when 252416 then 849 
 when 150965 then 850 
 when 215281 then 851 
 when 20002 then 852 
 when 305037 then 853 
 when 289963 then 854 
 when 189292 then 855 
 when 213180 then 856 
 when 191577 then 857 
 when 132455 then 858 
 when 137855 then 859 
 when 44844 then 860 
 when 44833 then 861 
 when 103202 then 862 
 when 278381 then 863 
 when 124130 then 864 
 when 206060 then 865 
 when 155283 then 866 
 when 208859 then 867 
 when 271562 then 868 
 when 262616 then 869 
 when 205609 then 870 
 when 281683 then 871 
 when 293002 then 872 
 when 267176 then 873 
 when 44837 then 874 
 when 181921 then 875 
 when 262787 then 876 
 when 141444 then 877 
 when 164979 then 878 
 when 221074 then 879 
 when 263464 then 880 
 when 213251 then 881 
 when 206286 then 882 
 when 40302 then 883 
 when 89707 then 884 
 when 40317 then 885 
 when 40308 then 886 
 when 277879 then 887 
 when 277880 then 888 
 when 10303 then 889 
 when 256340 then 890 
 when 207420 then 891 
 when 205606 then 892 
 when 213252 then 893 
 when 222425 then 894 
 when 44842 then 895 
 when 293284 then 896 
 when 276114 then 897 
 when 215600 then 898 
 when 44836 then 899 
 when 264163 then 900 
 when 264164 then 901 
 when 138559 then 902 
 when 247815 then 903 
 when 247801 then 904 
 when 163201 then 905 
 when 207421 then 906 
 when 257010 then 907 
 when 165139 then 908 
 when 214082 then 909 
 when 262607 then 910 
 when 100272 then 911 
 when 199015 then 912 
 when 281256 then 913 
 when 246100 then 914 
 when 94151 then 915 
 when 252478 then 916 
 when 202873 then 917 
 when 285211 then 918 
 when 298069 then 919 
 when 247800 then 920 
 when 287581 then 921 
 when 298074 then 922 
 when 181920 then 923 
 when 44835 then 924 
 when 178596 then 925 
 when 208117 then 926 
 when 292710 then 927 
 when 123999 then 928 
 when 125457 then 929 
 when 141491 then 930 
 when 252516 then 931 
 when 147047 then 932 
 when 247788 then 933 
 when 298714 then 934 
 when 40309 then 935 
 when 280534 then 936 
 when 264139 then 937 
 when 262342 then 938 
 when 279875 then 939 
 when 279872 then 940 
 when 245832 then 941 
 when 198816 then 942 
 when 175327 then 943 
 when 144172 then 944 
 when 211865 then 945 
 when 245235 then 946 
 when 245413 then 947 
 when 138443 then 948 
 when 161007 then 949 
 when 247626 then 950 
 when 286284 then 951 
 when 247699 then 952 
 when 247621 then 953 
 when 304955 then 954 
 when 285148 then 955 
 when 247712 then 956 
 when 247631 then 957 
 when 304811 then 958 
 when 203431 then 959 
 when 274645 then 960 
 when 141442 then 961 
 when 44845 then 962 
 when 133827 then 963 
 when 183620 then 964 
 when 206666 then 965 
 when 223032 then 966 
 when 207423 then 967 
 when 285396 then 968 
 when 290824 then 969 
 when 290830 then 970 
 when 305102 then 971 
 when 299269 then 972 
 when 255563 then 973 
 when 279979 then 974 
 when 207335 then 975 
 when 191750 then 976 
 when 212996 then 977 
 when 158994 then 978 
 when 175965 then 979 
 when 124132 then 980 
 when 78099 then 981 
 when 247534 then 982 
 when 222585 then 983 
 when 298710 then 984 
 when 287932 then 985 
 when 299030 then 986 
 when 298064 then 987 
 when 285782 then 988 
 when 165498 then 989 
 when 124319 then 990 
 when 117780 then 991 
 when 286206 then 992 
 when 304000 then 993 
 when 278349 then 994 
 when 126558 then 995 
 when 175892 then 996 
 when 222484 then 997 
 when 227159 then 998 
 when 170120 then 999 
 when 205231 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (199494,277408,277407,277397,277405,277406,277410,277409,277403,284192,223181,284191,291864,220936,291813,251706,283325,36622,283371,117774,247778,283257,264572,288921,288923,13368,129242,236929,283858,272035,283213,210301,91822,129326,123871,222418,247767,277404,13370,222422,286731,205607,236945,116595,283379,205604,222421,222424,36605,205608,36613,291845,152532,143454,199253,114201,302056,287764,216913,216914,216910,216911,197692,294587,309642,262116,276348,223177,262110,147471,188448,139987,275955,193838,249030,253191,192981,268752,252431,264770,266826,181144,181143,247202,268750,134500,195457,195458,165252,227668,268570,211446,260590,268561,260975,266384,268753,36024,176261,247210,249033,199045,199043,214426,247212,247211,36610,263414,272084,253192,264974,253193,264205,268751,193178,199044,260634,253159,212024,253157,253156,44655,114238,264969,270142,272136,282678,272085,262599,272086,262084,283265,289828,298405,36606,36608,288985,209922,212023,220446,260636,284422,220447,188447,272093,272644,272094,212823,260637,303608,268754,303607,266383,261808,298408,188446,272095,277728,212089,36623,294675,298407,193139,286757,296153,192324,281487,277729,212813,261957,262601,277726,289693,268051,298406,298409,36047,119052,149701,158037,118963,255511,303609,44653,44657,44656,153094,252569,44652,281157,154946,40287,291252,260629,204787,107584,291723,285532,212280,283281,281630,287957,253589,40312,247206,227610,149785,193837,227609,283220,203703,264203,309625,256579,283232,148973,250391,264970,283389,44675,255425,278253,283323,283372,264207,283329,296453,227669,293281,44674,264972,307862,246578,277730,268636,262597,225308,252482,277727,255014,254547,248858,290588,61944,288066,294688,12705,218419,218421,91819,12666,87502,155925,217477,310133,264967,254548,262113,19093,267834,117161,13387,13393,170313,13388,170314,193145,209128,254492,274428,213796,260834,145797,143656,13394,13395,8388,13390,116916,193144,245236,277039,8391,91821,8392,205600,287059,216706,173212,252835,287062,287250,205612,205599,13397,13396,13392,280250,257098,44629,170312,251562,285719,216921,252348,252347,214112,262259,8387,205603,216915,216918,216919,196899,216922,216905,283210,216916,216908,216909,216904,40364,151117,127352,126077,232437,216924,249587,205601,40286,40288,210682,266240,220611,249588,216907,220612,51483,51482,285530,51481,215619,269481,310314,23409,296464,40337,51493,264968,114053,36595,102137,23413,266601,36624,36607,216906,220610,105900,269615,285534,287585,193163,87656,205777,74998,249293,119450,205776,158090,51499,51485,103825,289268,91793,144147,220609,260554,291471,247362,89710,216278,201672,297546,260562,104297,87653,267920,51494,144547,289833,218420,114191,193158,40374,247360,260564,23408,23407,219848,36614,36619,173699,289418,262811,51502,188340,115864,289698,76572,254110,207007,51479,161895,74926,210684,260560,260552,217478,249292,282653,260561,271477,279430,193153,193152,193157,193147,306678,40276,301920,281593,281594,288076,285851,192980,94198,145772,242384,193149,23419,247488,222650,193146,249289,288073,275985,275983,296553,193143,266628,293278,277035,280316,40271,170184,51486,192979,192829,242377,10152,131287,249031,297549,266631,287061,216279,23410,247528,201671,274646,193137,247491,293071,293069,293070,266632,184495,178949,268579,268587,268569,268538,277693,296372,267685,270147,51496,268550,261810,268545,304938,297550,296455,298721,210683,222539,260563,277036,280321,280320,288582,273433,273434,203321,247529,279063,288583,192469,103815,216898,210595,79854,281084,298825,173188,222706,247485,36626,79793,222538,222537,280317,280318,266627,293138,277038,88520,36627,51500,268591,291860,227241,307740,213783,309733,309734,227189,277037,51478,124298,72903,118362,266865,247484,247500,247498,247495,293261,288383,264156,195456,247208,51501,199095,40266,158089,111984,288213,214894,210292,143333,134569,274125,40270,161190,262097,294887,304720,247209,266212,40258,111461,152377,191585,189019,266965,104864,114636,106369,122404,122415,133124,191785,305065,192875,122763,249639,188283,66260,137587,40295,147502,163726,129234,169698,249640,169095,270873,152417,204221,123916,248401,202351,155342,114014,158550,199242,266703,196068,269510,202874,191305,177536,262922,264982,116759,199591,201902,123902,170108,277320,138367,176523,188884,217041,35035,202048,255698,107138,165118,156361,263234,125777,193108,273793,251455,87677,168708,154969,201522,256758,193477,193478,35032,191304,119180,248404,165120,260753,125608,133832,133831,116155,155604,103201,109823,131365,193533,290544,190017,35031,205866,193604,213442,119909,205865,220055,266213,205395,160859,192347,157813,257017,189166,266940,216998,132077,168536,206588,192328,35036,151724,251459,204766,48699,247437,261539,155320,192487,251979,147503,38932,152463,138439,144905,266942,84067,44839,245695,44748,268451,268445,279982,247619,281742,280169,206320,206983,263460,263455,44843,213317,260640,262614,129235,38930,213253,248698,252461,138567,217040,268476,268262,268359,268409,264161,247820,268450,136939,138297,38931,274643,269278,192488,245694,47938,193107,271642,262617,262613,134604,217042,116148,205605,222595,113147,144548,152464,249560,251683,262138,206321,189649,111392,245412,278792,4740,218523,194075,4738,289961,274644,154963,247816,268416,268447,268427,268448,279949,268337,268391,280015,312404,279951,44661,257263,73024,253983,251210,277899,277317,215153,266941,267070,262612,113728,24188,161941,116008,124007,217043,268357,145486,170107,196898,216883,132529,138442,289964,103054,214886,253370,280982,214586,214587,4741,48169,134600,257284,204767,220134,247439,281141,305251,274642,262788,151157,280866,249009,252550,251681,254207,188659,247438,192327,267296,225324,297979,138563,153403,144193,305036,291312,293202,132723,48701,193109,262999,48172,262615,213453,132724,213538,222481,220615,281649,301145,252416,150965,215281,20002,305037,289963,189292,213180,191577,132455,137855,44844,44833,103202,278381,124130,206060,155283,208859,271562,262616,205609,281683,293002,267176,44837,181921,262787,141444,164979,221074,263464,213251,206286,40302,89707,40317,40308,277879,277880,10303,256340,207420,205606,213252,222425,44842,293284,276114,215600,44836,264163,264164,138559,247815,247801,163201,207421,257010,165139,214082,262607,100272,199015,281256,246100,94151,252478,202873,285211,298069,247800,287581,298074,181920,44835,178596,208117,292710,123999,125457,141491,252516,147047,247788,298714,40309,280534,264139,262342,279875,279872,245832,198816,175327,144172,211865,245235,245413,138443,161007,247626,286284,247699,247621,304955,285148,247712,247631,304811,203431,274645,141442,44845,133827,183620,206666,223032,207423,285396,290824,290830,305102,299269,255563,279979,207335,191750,212996,158994,175965,124132,78099,247534,222585,298710,287932,299030,298064,285782,165498,124319,117780,286206,304000,278349,126558,175892,222484,227159,170120,205231)
 
 
  and ltrim(rtrim(lower(a.dept))) = 'firearms'
 
	and a.of3='45 ACP'
	
 group by a.style_id 
  order by  instock desc, ranking asc

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

select distinct brand from mysearch
  order by brand asc

select distinct of3 from mysearch
  order by of3 asc

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =214586 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=214586 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 214586 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 214586 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'Jul 19, 2024 12:42:21' and
end_date >= 'Jul 19, 2024 12:42:21'
and store_id=10 and style_id=214586

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 214586 
and (a.start_date<= 'Jul 19, 2024 12:42:21' or a.active = 1)
and a.end_date >= 'Jul 19, 2024 12:42:21'
order by a.promo_id desc

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='1911 Pistols' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=214586  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=214586
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =250391 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=250391 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 250391 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 250391 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Single Shot Pistols' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Firearms' and typ='Single Shot Pistols' and subtyp_1='Derringers' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=250391  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=250391
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =143656 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=143656 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 143656 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 143656 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Single Shot Pistols' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Firearms' and typ='Single Shot Pistols' and subtyp_1='Derringers' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=143656  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=143656
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =202874 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=202874 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 202874 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202874 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=202874  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=202874
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =205395 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=205395 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 205395 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 205395 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=205395  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=205395
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =263455 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=263455 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 263455 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 263455 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=263455  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=263455
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =263464 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=263464 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 263464 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 263464 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=263464  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=263464
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =202873 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=202873 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 202873 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202873 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=202873  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=202873
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =203431 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=203431 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 203431 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 203431 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=203431  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=203431
												and status='A' 
												and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
[email protected]
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
[email protected]
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/kword/.22%20single%20shot%20pistol/of3/45-acp/dept/firearms
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=10.200.30.6
PATH_INFO=/kword/.22 single shot pistol/of3/45-acp/dept/firearms
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=1044200
cftoken=19f97640ab27db51-F6B3023C-A31B-7188-EBC6F0FB55EDB2B8
hitcount=1
lastvisit={ts '2024-07-19 12:42:20'}
timecreated={ts '2024-07-19 12:42:20'}
urltoken=CFID=1044200&CFTOKEN=19f97640ab27db51-F6B3023C-A31B-7188-EBC6F0FB55EDB2B8

Cookie Variables:
CFID=1044200
CFTOKEN=19f97640ab27db51-F6B3023C-A31B-7188-EBC6F0FB55EDB2B8
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
USERNAME=

Form Fields:
KWORD=.22 single shot pistol
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=1044200
cftoken=19f97640ab27db51-F6B3023C-A31B-7188-EBC6F0FB55EDB2B8
cs=/index.cfm
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_1044200_19f97640ab27db51-F6B3023C-A31B-7188-EBC6F0FB55EDB2B8
strarray=Array (0)
urltoken=CFID=1044200&CFTOKEN=19f97640ab27db51-F6B3023C-A31B-7188-EBC6F0FB55EDB2B8

URL Parameters:
BRAND=
CLEARANCE=
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
dept=firearms
kword=.22 single shot pistol
of3=45-acp